A time enabled feature is an Oracle Spatial table that is version enabled using the valid time functionality of Oracle workspace manager. When this functionality is enabled in the database table a field of type WM_PERIOD is added, which contains a FromTime and a ToTime value.

CREATE TYPE WM_PERIOD AS OBJECT (
validFrom TIMESTAMP WITH TIME ZONE,
validTill TIMESTAMP WITH TIME ZONE);

This type of feature can be registered in Bentley Geospatial Administrator. Once the features are discovered and registered, they are threaded specially by Bentley Map.

In the extraction wizard, this type of feature is represented by an hourglass icon.

An extraction using the current time, past or future, can be performed on time enabled features.

Two fields, StartDate and EndDate, are added to the features in Bentley Map. These fields set the time on the features. By default, when posting to this kind of feature, the following occurs:

For new inserts, a new row is created in the table.

• FromTime — Now (by default) or Bentley Map user input time
• ToTime — Infinite (by default) or Bentley Map user input

For updates, the updated row is copied in the same table.

• FromTime — Now (by default) or Bentley Map user input time
• ToTime — Infinite (by default) or Bentley Map user input

The times on the current row are adjusted.

• FromTime — Actual value
• ToTime — Now (by default) or Bentley Map user input time

Some rules apply to user input values. In Oracle, creating an overlapping time interval for the same row is prohibited. A posting can fail for this reason. If this happens, adjust the FromTime and/or ToTime.

When deleting, the times on the current row are adjusted.

• FromTime — Actual value
• ToTime — Now